LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35
Default Formatting currency in cell

I have a spreadsheet that was sent to me and the "wage" amount does not have
decimals included. I want to add a decimal to all of the wages, but not for
sure how to do that without having to do each one separtely. Can this be
done? Also, when I enter a decimal the number rounds up. Say, the number in
the cell is 13525869 and I want it to read 135258.69. But when the decimal is
entered but then it shows up as 135258.71 when I hit enter.

Thanks
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditionally formatting currency Yendorian Excel Worksheet Functions 3 June 15th 07 12:13 AM
conditional formatting for currency TC Excel Worksheet Functions 1 May 20th 06 01:55 PM
Currency Formatting chalky Excel Discussion (Misc queries) 1 January 18th 06 01:51 PM
Currency Formatting. John Smith Excel Discussion (Misc queries) 3 November 1st 05 02:21 PM
Currency Formatting Janbri Excel Discussion (Misc queries) 2 July 3rd 05 03:58 PM


All times are GMT +1. The time now is 02:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"