Posted to microsoft.public.excel.misc

narp[_2_]

external usenet poster

Posts: 15

decimal places

I have a sql query that pulls info from Great Plains into excel. The format
in GP is 2 decimal places however when it pulls into excel it puts the
decimal at the end of the number. For example, in GP it is entered as .88
but in excel it reads 88. How do I change the format to put the decimal in
front of the last 2 digits. I've tried all the choices in the format box.
--
narp

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Decimal Places	Tafmutt	Excel Discussion (Misc queries)	2	March 14th 07 09:22 PM
Subtracting two 2-decimal place numbers gives result 13-decimal places?	[email protected]	Excel Worksheet Functions	5	March 12th 07 10:38 PM
FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT.	SUKYKITTY	Excel Discussion (Misc queries)	3	July 6th 05 01:50 PM
decimal places	HB	Excel Discussion (Misc queries)	4	March 15th 05 02:19 AM
add 2 decimal places	Bill M.	Excel Discussion (Misc queries)	2	January 28th 05 10:21 PM

All times are GMT +1. The time now is 07:31 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us