|
|
Remove decimal but keep entire number
I need the price to display with no decimal, but retaining the numbers that
appear after the decimal. For example $47.50 would be 4750.
Example 119.00 would be 11900
Please help
--
Tickfarmer
|
|
0
|
|
|
|
Reply
|
 Utf
|
2/25/2010 6:23:02 PM |
|
in adjacent column multiply by 100.
Tickfarmer wrote:
> I need the price to display with no decimal, but retaining the numbers that
> appear after the decimal. For example $47.50 would be 4750.
> Example 119.00 would be 11900
> Please help
>
|
|
|
0
|
|
|
|
Reply
|
Bob
|
2/25/2010 6:31:31 PM
|
|
For excel, changing $47.50 to 4750 is not a "display" issue. You need to
multiple it by 100 and put it in another column, and format that column
number with 0 decimals.
"Tickfarmer" wrote:
> I need the price to display with no decimal, but retaining the numbers that
> appear after the decimal. For example $47.50 would be 4750.
> Example 119.00 would be 11900
> Please help
>
> --
> Tickfarmer
|
|
|
0
|
|
|
|
Reply
|
Utf
|
2/25/2010 6:32:01 PM
|
|
Maybe just multiply by 100.
A1 = $47.50
=A1*100
= 4750
--
Biff
Microsoft Excel MVP
"Tickfarmer" <Tickfarmer@discussions.microsoft.com> wrote in message
news:4D5DD301-00D4-451B-96CB-281BC79A725E@microsoft.com...
>I need the price to display with no decimal, but retaining the numbers that
> appear after the decimal. For example $47.50 would be 4750.
> Example 119.00 would be 11900
> Please help
>
> --
> Tickfarmer
|
|
|
0
|
|
|
|
Reply
|
T
|
2/25/2010 6:33:56 PM
|
|
Thanks so much.
--
Tickfarmer
"Toothsome Papa" wrote:
> For excel, changing $47.50 to 4750 is not a "display" issue. You need to
> multiple it by 100 and put it in another column, and format that column
> number with 0 decimals.
>
> "Tickfarmer" wrote:
>
> > I need the price to display with no decimal, but retaining the numbers that
> > appear after the decimal. For example $47.50 would be 4750.
> > Example 119.00 would be 11900
> > Please help
> >
> > --
> > Tickfarmer
|
|
|
0
|
|
|
|
Reply
|
Utf
|
2/25/2010 6:37:01 PM
|
|
I personally have never done that in Excel. I tried modifying the cell format
rule but had no success.
Another idea(if you really have to get that kind of numeric format as soon
as possible) would be to create another column and just add a(for example)
=CELL*100 formula.
Let me know how it goes
--
Vicente Tulliano
"Tickfarmer" wrote:
> I need the price to display with no decimal, but retaining the numbers that
> appear after the decimal. For example $47.50 would be 4750.
> Example 119.00 would be 11900
> Please help
>
> --
> Tickfarmer
|
|
|
-1
|
|
|
|
Reply
|
Utf
|
2/25/2010 6:37:02 PM
|
|
|
5 Replies
1176 Views
(page loaded in 0.258 seconds)
Similiar Articles: Remove decimal but keep entire number - microsoft.public.excel ...I need the price to display with no decimal, but retaining the numbers that appear after the decimal. For example $47.50 would be 4750. Example 119... Decimal/Percentage to Whole Number - microsoft.public.excel.misc ...Remove decimal but keep entire number - microsoft.public.excel ... Decimal/Percentage to Whole Number - microsoft.public.excel.misc ... Remove decimal but keep entire ... Zero decimal getting dropped. - microsoft.public.access.forms ...Remove decimal but keep entire number - microsoft.public.excel ... Zero decimal getting dropped. - microsoft.public.access.forms ... Remove decimal but keep entire number ... Appending Rounds Decimal to Whole Number - microsoft.public.access ...Remove decimal but keep entire number - microsoft.public.excel ... Formatting currency with the cents but without the decimal point ... Appending Rounds Decimal to Whole ... Delete first 2 digits off a number - microsoft.public.access ...Rounding off numbers to 2 decimal places. - microsoft.public ... Rounding off numbers to 2 decimal places. - microsoft.public ... Remove decimal but keep entire number ... How do I extract the decimal places from a number in excel ...Remove decimal but keep entire number - microsoft.public.excel ... How do I extract the decimal places from a number in excel ... Remove decimal but keep entire number ... Remove characters in an ASCII decimal range: How To? - microsoft ...Remove decimal but keep entire number - microsoft.public.excel ... Remove decimal but keep entire number - microsoft.public.excel ... Zero decimal getting dropped ... How to determine the number of decimal places in a number ...Remove decimal but keep entire number - microsoft.public.excel ... How to determine the number of decimal places in a number ... Remove decimal but keep entire number ... Query to delete characters to the right of a decimal point ...issue with decimal points - microsoft.public.access Remove decimal but keep entire number ... the last 2 digits on the right appearing after the decimal point. ... Fraction number in Access - microsoft.public.access.forms ...Remove decimal but keep entire number - microsoft.public.excel ... Remove decimal but keep entire number - microsoft.public.excel ... Fraction number in Access - microsoft ... Remove decimal but keep entire number ExcelI need the price to display with no decimal, but retaining the numbers that appear after the decimal. For example $47.50 would be 4750. Example 119.00 wou Remove decimal but keep entire number - microsoft.public.excel ...I need the price to display with no decimal, but retaining the numbers that appear after the decimal. For example $47.50 would be 4750. Example 119... Remove decimal but keep entire number - ExcelBanterExcel Discussion (Misc queries) ... I need the price to display with no decimal, but retaining the numbers that appear ... in adjacent column multiply by 100 ... Removing decimal places on whole currency numbers only ...Removing decimal places on whole currency numbers only? I'd like to remove the decimal places from currency numbers that have no ... Once I can keep the program ... How do I remove decimal point from numeric number in SQL select?Subscribe now for full access to Experts Exchange and get ... Keywords: How, do, I, remove, decimal, point, from, numeric, number, in, SQL, select? 7/23/2012 2:13:38 AM
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
68 followers. 