Good Afternoon!
I have a list of data that represents hundred thousands, however it just says hundred values in the column. What can I used to change 100 -> $ 100,000.00 (in number formatting)
Good Afternoon!
I have a list of data that represents hundred thousands, however it just says hundred values in the column. What can I used to change 100 -> $ 100,000.00 (in number formatting)
Put 1000 in a cell. Copy it. Past Special with Multiply on your range of numbers. Format them as currency.
Pauley
--------
If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).
You might want to check the format of the field in case the data entered is actually 100000 and just formatted to show it as in thousands.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks